﻿CREATE VIEW dbo.[Current Content Keywords]
AS
SELECT     dbo.EmergencyMessageContent.ContentDescription, dbo.EmergencyMessageContent.Id, dbo.EmergencyMessageContent.EmergencyMessageContainerId, 
                      dbo.ContentTopic.Value, dbo.ContentTopic.ListURI
FROM         dbo.EmergencyMessageContent INNER JOIN
                      dbo.ContentTopic ON dbo.EmergencyMessageContent.Id = dbo.ContentTopic.EmergencyMessageContentId